iLoADER

HOME

Default Environment Variables

The following default variables are available to use in scripts:

"2">Project name of the tenant that iLoader is connected to. No slashes. Preserves case sensitivity as set up in Project Navigator.

VariableReturnsExample
ALT_BROKERSERVER The name of the machine that is running connection broker. Note: this is the machine name, not the IP address. REPORT %ALT_BROKERSERVER%In INFO File:

ALT_PROJECTNAME

BR-JWHITE-LT

REPORT %ALT_PROJECTNAME%In INFO File: 21/10/2009 19:09:41 : Project1

ALT_PROJECTBASE

Directory for the Project Base Location.

REPORT %ALT_PROJECTBASE%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1

ALT_CERBERUS

Cerberus path and file name for the active project. The path is relative to the NucEngine.exe that iLoader is connected to.

REPORT %ALT_CERBERUS%In INFO File: 21/10/2009 19:09:41 : C:\windows\system32\cerberus.ini

ALT_CERLOG

Cerlog path and file name for the active project. The path is relative to the NucEngine.exe that iLoader is connected to.

REPORT %ALT_CERLOG%In INFO File: 21/10/2009 19:09:41 : C:\cerlog.txt

ALT_ALTERIANPROGRAMFILE

Location of the Alterian Program files directory. This is the directory that contains the NucEngine.exe that iLoader is connected to.

REPORT %ALT_ALTERIANPROGRAMFILE %In INFO File: C:\Program Files\Alterian\

ALT_REPOSITORYFOLDER

Path of the active repository folder. The path is relative to the NucEngine.exe that iLoader is connected to.

Note: in the case of split repositories (i.e. where the History is in a different location), this is the principal repository.

REPORT %ALT_REPOSITORYFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\Repository\

ALT_ENGINEPASSWORD

Can be used in scripts to pass the Engine password to scripts run in the BATCH command as a command line parameter. This means that the scripts do not have to contain a hard-coded password themselves.

Ensure that iLoader stores the password in the correct case.

Example iLoader Command:

BATCH {c:\windows\system32\cscript c:\iloader_scripts\script.vbs %ALT_PROJECTNAME% %ALT_ENGINEPASSWORD%}

The above command will run the script to start Engine and display the name of the demo database.

ALT_ENG_VERSION

Version number of the Engine instance that iLoader is connected to.

This is found from the version number of NucEngine.exe

REPORT %ALT_ENG_VERSION% In INFO File: 4.1.0.9200

ALT_ILS_VERSION

Version number of the Engine instance that iLoader is connected to.

This is found from the version number of LoaderServer.exe

REPORT %ALT_ILS_VERSION% In INFO File: 4.1.0.9200

ALT_ILC_VERSION

Version number of the Engine instance that iLoader is connected to.

This is found from the version number of LoaderClient.exe

REPORT %ALT_ILC_VERSION% In INFO File: 4.1.0.9200

ALT_IL_CONFIGFILEFOLDER

Path of the iLoader Configuration Folder. The path is relative to LoaderServer.exe.

REPORT %ALT_IL_CONFIGFILEFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\

ALT_IL_SCRIPTSETNAME

The Name of the active scriptset.

REPORT %ALT_IL_SCRIPTSETNAME%In INFO File: Config1

ALT_IL_SCRIPTFOLDER

Path of the iLoader Script Folder.

REPORT %ALT_IL_SCRIPTFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Scripts\

ALT_IL_DECODEFOLDER

Path of the iLoader Decode Folder.

REPORT %ALT_IL_DECODEFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Decodes\

ALT_IL_BACKUPFOLDER

Path of the iLoader Backup Folder.

REPORT %ALT_IL_BACKUPFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Backup

ALT_IL_DATAFOLDER

Path of the iLoader Data Folder.

REPORT %ALT_IL_DATAFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Data\

ALT_IL_REPORTFOLDER

Path of the iLoader Report Folder.

REPORT %ALT_IL_REPORTFOLDER%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Report\

ALT_IL_CONTROLFILENAME

The name of the control file.

REPORT %ALT_IL_CONTROLFILENAME%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Scripts\Control.txt

ALT_IL_PRELOADFILENAME

The name of the Preload file.

REPORT %ALT_IL_PRELOADFILENAME%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Scripts\Preload.txt

ALT_IL_LINKSCRIPTFILENAME

The name of the LinkScript file.

REPORT %ALT_IL_LINKSCRIPTFILENAME%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Scripts\Link.txt

ALT_IL_DATATRANSFILENAME

The name of the data transformation file.

REPORT %ALT_IL_DATATRANSFILENAME%In INFO File:

ALT_IL_POSTLOADFILENAME

The name of the PostLoad file.

REPORT %ALT_IL_POSTLOADFILENAME%In INFO File: C:\Program Files\Alterian\ProjectBase\Project1\AppData\iLoader\Config1\Scripts\Postload.txt

ALT_IL_LOG_DATETIMESTAMP

The Prefix for the iLoader Log

Format = CCYYMMDD_HHMMSS_

Note: this field name ends with "_".

REPORT %ALT_IL_DATETIMESTAMP%In INFO File: 20091021_215052_

ALT_IL_RUNSTARTTIME

The time that iLoader started the current run.

Format = HHMMSS.

24 hour.

Time is local to LoaderServer.exe

REPORT %ALT_IL_RUNSTARTTIME%In INFO File: 152114

ALT_IL_RUNSTARTDATE

The date that iLoader started the current run.

Format = CCYYMMDD

REPORT %ALT_IL_RUNSTARTDATE%In INFO File: 20090921

ALT_IL_CURRENTTIME

The current time.

Format = HHMMSS.

24 hour.

Time is local to LoaderServer.exe

REPORT %ALT_IL_CURRENTTIME%In INFO File: 152114

ALT_IL_CURRENTDATE

The current date.

Format = CCYYMMDD

REPORT %ALT_IL_CURRENTDATE%In INFO File: 20090921

ALT_LAST_TABLELOAD_LOADED

The number of records loaded in the last data load (dispatch ND_ISTATS_LOADED (1)).

REPORT %ALT_LAST_TABLELOAD_LOADED%In INFO File:

ALT_LAST_TABLELOAD_RECSAPPENDED

The number of records appended in the last data load (dispatch ND_ISTATS_APPENDED (3)).

REPORT %ALT_LAST_TABLELOAD_RECSAPPENDED%In INFO File:

ALT_LAST_TABLELOAD_RECSUPDATED

The number of records updated in the last data load (dispatch ND_ISTATS_UPDATED (2)).

REPORT %ALT_LAST_TABLELOAD_RECSUPDATED%In INFO File:

ALT_IL_CURRENTSCRIPTNAME

Name of current script being parsed (even if in a PROCESS command).

REPORT %ALT_IL_CURRENTSCRIPTNAME%

PROCESS x_subscript.txt

REPORT %ALT_IL_CURRENTSCRIPTNAME%In INFO File: Datatrans.txt

X_subscript.txt

ALT_IL_CURRENTSCRIPTPATH

Path of current script being parsed (even if in a PROCESS command).

REPORT %ALT_IL_CURRENTSCRIPTPATH%In INFO File: \\server\scripts\macros\

ALT_IL_CURRENTSCRIPTMETHOD

Type of current script being parsed (even if in a PROCESS command).

REPORT %ALT_IL_CURRENTSCRIPTMETHOD%In INFO File: Data Transformation

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice